Hello, I'd like to be able to set the Font Size of a text box to "fill" the whole text box widthwise and even sometimes height-wise. Basically, I am writing a few display signs in SSRS and I need a way to fill the width and sometimes the height of the sign so that the sign looks good. Right now I'm doing this: For the Font Size property: =Iif(len(Fields!SignPriceText.Value)<8,"200pt",Iif(len(Fields!SignPriceText.Value)<9,"172pt",Iif(len(Fields!SignPriceText.Value)<10,"164pt",Iif(len(Fields!SignPriceText.Value)<11,"150pt","142pt")))) The problem here is that if it's WATERMELON the W's and the M's take up a ton of space and the text will cut off or wrap. If it's a description like LUCINI SICILIAN it won't fill the width because of all those I's taking up less space that those W's and M's. Thanks, Bradley

Hi BradleySCS, According to your description, some values won’t fill the width of textbox, and you need a way to fill the width and height, right? Please correct me if my understanding is wrong. In that case, I am afraid we need to increase or decrease the textbox width manually. Columns do not automatically adjust horizontally to accommodate text in Reporting Services. For more information about it, please refer to the following article, How to: Change Row Height or Column Width (Reporting Services): http://msdn.microsoft.com/en-us/library/cc645971(v=sql.100).aspx If you have any question, please feel free to ask. Thanks, Eileen

Hi Eileen, I do not want to adjust the width or the height of the text box. Instead I want to adjust the font size of the text so that it will size to the maximum size to fill the existing text box and display all the text. Basically what most labeling writing applications currently do. Maybe there's a third-party control that has this functionality? thanks, Bradley

Also looking for a way to keep the size of text boxes constant, and to make the text font dynamically size itself to fill the text box.